﻿using Newtonsoft.Json.Linq;
using QJY.Data;
using System;
using System.Data;
using System.Linq;

namespace QJY.API
{
    public class SXGLManage
    {


        public class QJ_JWB : BaseEFDaoJW<QJ_JW>
        {

        }

        #region PC端



        public void SXINDEX(JObject context, Msg_Result msg, string P1, string P2, JH_Auth_UserB.UserInfo UserInfo)
        {

            DataTable dtSXS = new JH_Auth_QYB().GetDTByCommand("SELECT * FROM qj_sx_sxs");
            msg.Result = dtSXS;
            msg.Result1 = new JH_Auth_QYB().GetDTByCommand("SELECT count(*) AS sbsl FROM qj_sx_sb").Rows[0][0].ToString();
            msg.Result2 = new JH_Auth_QYB().GetDTByCommand("SELECT DISTINCT dname FROM qj_sx_sxs");

        }

        #endregion





    }
}